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