UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TUSfdu/UO94BphMLID6DNYkqAMnT2vNn6oi5J3oh3w4='
WHERE
key_id = '7ffd52c976f83188573caec8c6531e0ed7e90a2f62e4f48600389af5effdfa2f'
AND (
token = 'TUSfdu/UO94BphMLID6DNYkqAMnT2vNn6oi5J3oh3w4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)