UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dlztb/nO3LePJb+hZLgYLLVAiUWHzKZOmoOsM98z6uM='
WHERE
key_id = 'ab8b8374d84eb78678c7349657355de1d302b1e2659b84363a42083f32e5203a'
AND (
token = 'dlztb/nO3LePJb+hZLgYLLVAiUWHzKZOmoOsM98z6uM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)