UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1cPiItiGoGm+86Etnt+d+ckE6YxN8A+dwF6M5agoBC8='
WHERE
key_id = 'e742e55b14826349d7fe08c527b06500c4d4bc81855578604d31c5d50af2897f'
AND (
token = '1cPiItiGoGm+86Etnt+d+ckE6YxN8A+dwF6M5agoBC8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)