UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wwivxchA+/4D0nFWGmspVg44Ew4ovKYLWonEJh+95qY='
WHERE
key_id = 'a731df5f3ad01100f51b46e699bf1cb8ca1de0e48f534bf6a4b9b0735f6de2a5'
AND (
token = 'wwivxchA+/4D0nFWGmspVg44Ew4ovKYLWonEJh+95qY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)