UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MJd8FF1M0hmshbsOr4KgD/+zSg4il2f4JVS6hDz5qhA='
WHERE
key_id = 'e7f71e7cc596199d86b2d2c397dcb8b274fc56f29d98bce578c197639c147cce'
AND (
token = 'MJd8FF1M0hmshbsOr4KgD/+zSg4il2f4JVS6hDz5qhA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)