UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yzVLA+rGMziAX8GXxAWlxQsA8lvmYir/bFjb4IN5B7E='
WHERE
key_id = 'c8e7a0bc9d142d2a0207431e106590694577e2d788f535a5bba3e8335987683e'
AND (
token = 'yzVLA+rGMziAX8GXxAWlxQsA8lvmYir/bFjb4IN5B7E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)