UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n/1fh5plcxmbKM0/lfUSxCzBSr97bLGWjcGXeyVVEaE='
WHERE
key_id = 'a5c04fe0b097818f1c73dd8071f170c1d4782de23777411a0a79a3675b377630'
AND (
token = 'n/1fh5plcxmbKM0/lfUSxCzBSr97bLGWjcGXeyVVEaE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)