UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6gzEtPASSyECgA7Sme0+qRlNEe7bDbMlO9Zgsb6l8BI='
WHERE
key_id = 'de512b243d4bf3642cf9f02550262a06ae1a0868cedb3cf9d30ca0ab6a696f57'
AND (
token = '6gzEtPASSyECgA7Sme0+qRlNEe7bDbMlO9Zgsb6l8BI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)