UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xs0gEN9wr8DJeBN4KxWYXOoc4pqw6Zppwh7ah+i5BFc='
WHERE
key_id = 'b670d9abc6d6fac4502e3e75360d517c8edfdf23d2db1fced3f02eb55989b89b'
AND (
token = 'xs0gEN9wr8DJeBN4KxWYXOoc4pqw6Zppwh7ah+i5BFc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)