UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IjnXY/q3djo2jmgKA6hVsMLlgDj0+McA3YcZDEdC5jk='
WHERE
key_id = '0a5092d843df9270e7d09058bef82808860f71e8786de66009996f5c6583e54b'
AND (
token = 'IjnXY/q3djo2jmgKA6hVsMLlgDj0+McA3YcZDEdC5jk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)