UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KZDkQ77u4g8PAyHg2CUrxuRwB5n2Ra+dpD3HWfE4Y+c='
WHERE
key_id = 'd3ca4c528703a33c036b6b0d543b43e72e20bcbb9638ec9f770deb9344220599'
AND (
token = 'KZDkQ77u4g8PAyHg2CUrxuRwB5n2Ra+dpD3HWfE4Y+c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)