UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1shXY8UB9KSS1WGJQ48CkW2QOtKyPEhrSxS+DLHFTWo='
WHERE
key_id = '28cbdef5fa62465abcf4ef014637873f8dbc323c55d5dfaaeea78c32d6ffa3a2'
AND (
token = '1shXY8UB9KSS1WGJQ48CkW2QOtKyPEhrSxS+DLHFTWo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)