UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '04a5siCta36fmeeVIyBYJmC57AZw68OVtCU8lGOZHSU='
WHERE
key_id = 'da52e3296292420431c69a5a2f6ef205eac40450fa6992ba4fc3ab2d69b4a603'
AND (
token = '04a5siCta36fmeeVIyBYJmC57AZw68OVtCU8lGOZHSU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)