UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'en88343fy0XZYwtb60Tf5lqT8s8ZMBwj/cWD4iZ3+jI='
WHERE
key_id = 'a19ea0f8a5d3ecedfa374abc0c20ea0be8d7370122b220141a5d412a5747aea0'
AND (
token = 'en88343fy0XZYwtb60Tf5lqT8s8ZMBwj/cWD4iZ3+jI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)