UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9pgCwFt0y+W7Vk1PKEeeiuDIAFxUIYGy7hVCUik21sg='
WHERE
key_id = '9b41f9a66c058aec04e68b0bccd68a5356905332bd642902fb9b0563b7a817c1'
AND (
token = '9pgCwFt0y+W7Vk1PKEeeiuDIAFxUIYGy7hVCUik21sg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)