UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rTTDRIpp4AeaOuItxXjgJ7KsFpGToKqz4jpLrsitolM='
WHERE
key_id = 'ceb78fc733afabd01e93a4b50fec3517f38b927e44a1d6de129697364d40b440'
AND (
token = 'rTTDRIpp4AeaOuItxXjgJ7KsFpGToKqz4jpLrsitolM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)