UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xNHj6PB0QR+VFx1aa0D8KUn14CqC6coYWC3oHs5ZClg='
WHERE
key_id = '3145d6ddbf8fc60a552069af7858e2771ad69b14cf0c4a546959dcbc312b5704'
AND (
token = 'xNHj6PB0QR+VFx1aa0D8KUn14CqC6coYWC3oHs5ZClg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)