UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lBkMekKtnA10OG3PwGAL0G/QTQfVSIS4oI+1H7q8cKI='
WHERE
key_id = 'bdc96f4e45b5b058bcff92a74fd481754157cf53fc2021d84e98e6fc5027ae23'
AND (
token = 'lBkMekKtnA10OG3PwGAL0G/QTQfVSIS4oI+1H7q8cKI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)