UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VJG6G0yrPQB05COKJ/ghYp33eeSV9BdxIikqSxGCFCo='
WHERE
key_id = 'd5084f7ceeb631ac986d701fdb8ce038888116969e099188c8c98bf72e180a39'
AND (
token = 'VJG6G0yrPQB05COKJ/ghYp33eeSV9BdxIikqSxGCFCo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)