UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KnBADZ7rqgoSt2lJ0E251MsAcDFdsnYeDD29F8BXMXk='
WHERE
key_id = '530872ea525f47c5b0c6f4937cf5fa9da06c223b8212ac84b9aebe862baa47c6'
AND (
token = 'KnBADZ7rqgoSt2lJ0E251MsAcDFdsnYeDD29F8BXMXk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)