UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XeW/fDd5CPDLQ2gmwtNSBSgK7YeaazUXdJd9qfLFbFU='
WHERE
key_id = '3d808e14305b4be36c9afa612d83f680ca6463ef880e42996453b6bc81fb4ab1'
AND (
token = 'XeW/fDd5CPDLQ2gmwtNSBSgK7YeaazUXdJd9qfLFbFU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)