UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C9e4ZwtkiUx/Y0KbBsIq/gsqHjO4Qj+11gAMj/L6r3w='
WHERE
key_id = 'cdda843f4146453f30e278894ca85a18c01b49672364439e9a3d6f2a5f9c96d4'
AND (
token = 'C9e4ZwtkiUx/Y0KbBsIq/gsqHjO4Qj+11gAMj/L6r3w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)