UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y0VeTtpg0tGKFEsOPZhvYd1sdNyQeQgq38GbySl/5lQ='
WHERE
key_id = 'e78f6f39c92c6f945c5e9bd1ac6172d57277f27869a5ef0da33209c6261587f1'
AND (
token = 'y0VeTtpg0tGKFEsOPZhvYd1sdNyQeQgq38GbySl/5lQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)