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