UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3Zj0ZdQAoSVv50zGJeb/fv187mnA0w5/1sNSVfGQefE='
WHERE
key_id = '690974e27bd9a40503b765815e6e4e6df6c092e03f27443e07e15dbc4b9102f1'
AND (
token = '3Zj0ZdQAoSVv50zGJeb/fv187mnA0w5/1sNSVfGQefE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)