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