UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'juaTTcJzz57ouqcF1bMyentWF8TOfolAUqjb44wOiiE='
WHERE
key_id = '0d2536d171567677c21e75a048badc0a136735b8c9503f9cbc113e6e6cd6bf92'
AND (
token = 'juaTTcJzz57ouqcF1bMyentWF8TOfolAUqjb44wOiiE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)