UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XRx+1qFMuhzCIGWinvj6mKK9wWRA1bdm/lmsURct2kw='
WHERE
key_id = '0e7cc93c881fb1ad86ecede91a8b206550db8a90f5f609b4fe3ae6523b4e863c'
AND (
token = 'XRx+1qFMuhzCIGWinvj6mKK9wWRA1bdm/lmsURct2kw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)