UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BV9ZgQENGQ0qbmCqjEOy7HlVup77wRScX/NiV6rQuSw='
WHERE
key_id = '709319479a605684595018a6d8c772b5967c557d0b4f57b2b1a7ecdb3572601d'
AND (
token = 'BV9ZgQENGQ0qbmCqjEOy7HlVup77wRScX/NiV6rQuSw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)