UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S8DGPcxdD/y0oY3lxW4ruKJML7GjGsxVQVwX8KPxbqY='
WHERE
key_id = 'e7307a327b3e86a7dd45938120307cc4b0a30b863af974e36ca6a6027907d1c3'
AND (
token = 'S8DGPcxdD/y0oY3lxW4ruKJML7GjGsxVQVwX8KPxbqY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)