UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QxovhnknJJS7QD2iArRXqkfW6OaWcisuCOE2EGX1oB8='
WHERE
key_id = '8e39222468e60410be54152c795cabd6b1b93b5500f020bf7a3d2666ea51cc0f'
AND (
token = 'QxovhnknJJS7QD2iArRXqkfW6OaWcisuCOE2EGX1oB8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)